<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <!-- InstanceBegin template="/Templates/anydbtest.dwt" codeOutsideHTMLIsLocked="false" -->
    <!-- InstanceBeginEditable name="doctitle" -->
    <title>AnyDbTest- AnyDbTest Technology</title>
    <!-- InstanceEndEditable -->
    <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
    <meta name="AnyDbTest" content="AnyDbTest Technology">
     
    <meta name="robots" content="index,follow">
    <meta name="generator" content="AnyDbTest">
    <meta name="author" content="AnyDbTest Technology">
    <meta name="rating" content="General">
    <meta name="revisit-after" content="2 days">
    <meta name="classification" content="Science &amp; Technology">
    <meta name="distribution" content="Global">
    <link rel="stylesheet" type="text/css" href="style.css">
    <!-- InstanceBeginEditable name="head" -->
    <meta name="keywords" content="AnyDbTest, UnitTest, Database UnitTest, DB UnitTest, Database automatic test,  Unit test, Database Unit test, DB Unit test, DB automatic test - AnyDbTest Technology">
    <meta name="description" content="AnyDbTest Technology is devoted to developing intuitive, easy-to-use application and database software products for different categories of users. ">
    
    <meta name="verify-v1" content="jtoQgM6ZR3hX97Oz6QTagqSIMpfii/1QvGqLmUwXaRk=" />
	<meta name="verify-v1" content="IOABVlRhHWtdWxVPLICWmSTPSkaSeWYo474PQ35jyHw=" />
    <!-- InstanceEndEditable -->

    <script type="text/JavaScript">
function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
    </script>

</head>
<body>
    <table width="960" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
            <td colspan="3">
                <img src="images/logo.png" width="960" height="87" border="0" usemap="#Map" onclick="MM_preloadImages('images/logo.png')" />
            </td>
        </tr>
        <tr>
            <td width="9" background="images/layout/site-left.gif">
                &nbsp;
            </td>
            <td width="942" height="37" background="images/layout/menu-bg.gif" onfocus="MM_preloadImages('images/layout/menu-bg.gif')">
                <table border="0" cellpadding="0" cellspacing="0">
                    <tbody>
                        <tr>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="index.html">Home</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="product.html">Product</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="download.html">Download</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="purchase.html">Purchase</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="support.html">Support</a></div>
                            </td>
                            <td class="MenuTop" width="120">
                                <div align="center">
                                    <a href="tutorial.html">Tutorial</a></div>
                            </td>
                            <!--
            <td class="MenuTop" width="120">
            <div align="center"><a href="affiliate.html">Affiliate</a></div>
            </td>
            -->
                        </tr>
                    </tbody>
                </table>
            </td>
            <td width="10" background="images/layout/site-right.gif">
                &nbsp;
            </td>
        </tr>
            <tr>
                <td colspan="3" background="images/layout/site-bg.gif">
                    <table border="0" cellpadding="0" cellspacing="0" width="960">
                        <tbody>
                            <tr>
                                <td height="50" width="9">
                                    &nbsp;
                                </td>
                                <td class="productText" bgcolor="#ffffff" valign="top" width="716">
                                    <div class="LeftColumnPadding">
                                        <!-- InstanceBeginEditable name="LeftRegion" -->
                                        <table border="0" cellpadding="0" cellspacing="0" width="100%">
                                            <tbody> 
                                                <tr>
                                                    <td class="productText">
                                                       <h2>  AnyDbTest<sup>&reg;</sup>2.4.5  <a href="ProductChangeLog.html" >[change log]</a>
                                                        <img src="images/new.gif" height="11" width="28"></h2>
                                                
                                                        <p align="justify">
                                                            <strong>AnyDbTest</strong> is the first and only automated DB unit testing tool available using XML as test case. AnyDbTest is just designed for DBA/DB developers. It supports all
                                                            kinds of popular database, such as Oracle, SQL Server, MySQL, and PostgreSQL etc.
                                                            <br />
                                                            <br />
                                                            AnyDbTest can also be used to validate replication, ETL, DTS & SSIS results. You can compare data of two SQL queries between two databases visually to see differences highlighted on the screen. You can even get the one-stop service for ETL and validation via built-in data pump and record-set comparison functions. 
                                                            <br />
                                                            <br />                                                            
                                                            According to data presented by a number of organizations, early testing can provide a cost improvement of as much as 100 times over the practice of relying on system testing that occurs after integration. (<a href="http://www.jot.fm/issues/issue_2007_05/column1/" target="_blank">Reference1</a>, 
                                                            <a href="http://www.ambysoft.com/essays/whyAgileWorksFeedback.html" target="_blank">Reference2</a>).
                                                            <br />
                                                            <br />
                                                            As one best practice of early testing, unit testing is a popular concept in application development. And in application developement community, there are many unit testing tools for developers, such as jUnit, NUnit, CppUnit etc.
                                                            <br />
                                                            <br />
                                                            But the database community has not yet embraced the advantages and strategies of this approach. Most database developers have little or no concept of unit testing and there are few, if any tools to support them. (Refer to this <a href="http://www.infoq.com/news/2008/10/Testing" target="_blank">article </a>from InfoQ). DBA/ DB developers had a long test feedback loop originated from
                                                            application developers/testers, they were not really benefiting from unit testing.
                                                            <br />
                                                            <br />
                                                            Now this problem is history. AnyDbTest has filled this gap with offerings of so many cool features. And it offers some killer highlights such as Sandbox test model and cross-different-type-database test. All of these help it to exceed other existing tools.
                                                            <br />
                                                            <br />
                                                            AnyDbTest is a good solution because it enabled DBA and DB developers to write test cases by configuring an XML file. <strong>You will not need to program at all.</strong> Obviously it is easier than in TSQL/PL-SQL based and Java/.Net based unit testing libraries. Plus, the verifying process will not be tedious and error-prone again. With AnyDbTest, you will greatly reduce the amount of errors in your database code/script.
                                                            <br />
                                                            <br />
                                                            <a href="ProductFeatureList.html" target="_blank">Features</a> specific to AnyDbTest:
                                                            <br />
                                                            <ul>
                                                                <li>Writes test case with XML, rather than Java/C++/C#/VB test case code </li>
                                                                <br />
                                                                <li>Many kinds of <a href="TutorialReference.html#RefStandardAssertion" target="_blank">standard assertion </a>supported, such as StrictEqual, SetEqual, IsSupersetOf, Overlaps, RecordCountEqual etc</li>
                                                                <br />
                                                                <li>Allows using Excel spreadsheet/XML as the source of the data for the tests</li>
                                                                <br />
                                                                <li>Supports Sandbox test model, if test will be done in sandbox, all database operations will be rolled back, meaning any changes will be undone</li>
                                                                <br />
                                                                <li>Unique cross-different-type-database testing, which means target and reference result set can come from two databases, even if one is SQL Server, another is Oracle.</li>
                                                                <br />
                                                            </ul>
                                                            The best way to see how AnyDbTest works is to read the <a href="TutorialQuickStart.html">Quickstart</a> (10 minutes). Developers who already have experience with unit testing will find everything they need to know on the <a href="TutorialCheatSheet.html">Cheat Sheet</a>.
                                                            <br />
                                                            <br />
                                                        </p>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td height="37">
                                                        <span class="productButtons"><a href="product.html">
                                                            <img src="images/layout/more-button.jpg" alt="More Info" border="0" height="26" width="101">&nbsp; </a>&nbsp;&nbsp;&nbsp; <a href="download.html#DownloadAnyDbTest">
                                                                <img src="images/layout/download-button.jpg" alt="Download" border="0" height="26" width="101">&nbsp; </a>&nbsp;&nbsp;&nbsp; <a href="purchase.html#OrderSection">
                                                                    <img src="images/layout/purchase-button.jpg" alt="Purchase Now" border="0" height="26" width="101">&nbsp; </a></span>
                                                    </td>
                                                </tr>
                                                <tr>
                                                    <td colspan="2">
                                                        <hr class="productSeparator">
                                                    </td>
                                                </tr>
                                            </tbody>
                                        </table>
                                        <br />
                                        <br />
                                        <!-- InstanceEndEditable -->
                                    </div>
                                </td>
                                <td background="images/layout/right-column-bg.gif" valign="top" width="226">
                                    <table border="0" cellpadding="0" cellspacing="0" width="100%">
                                        <tbody>
                                            
                                            <tr>
                                                <td valign="top">
                                                    <div class="RightColumnPadding">
                                                        <table border="0" cellpadding="0" cellspacing="0" width="96%">
                                                            <tbody>
															    
																<tr>
																   <td width="5%">
                                                                        &nbsp;
                                                                    </td>
                                                                    <td width="6%">
                                                                        &nbsp;
                                                                    </td>
                                                                    <td  width="89%">
                                                                        <h2>Quick links</h2>
                                                                    </td> 
                                                                </tr>
																
																<tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="ProductScreenshots.html">Screenshots </a>
                                                                    </td>
                                                                </tr>
																
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="ProductOtherToolsComp.html">Compare other tools</a>
                                                                    </td>
                                                                </tr>
   
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="TutorialQuickStart.html">QuickStart examples</a>
                                                                    </td>
                                                                </tr>
																
                                                                <tr>
                                                                    <td width="5%">
                                                                        <img src="images/spacer.gif" height="8" width="8">
                                                                    </td>
                                                                    <td width="6%">
                                                                        <div align="center">
                                                                            <img src="images/dot.gif" height="10" width="14"></div>
                                                                    </td>
                                                                    <td class="rightColumnNavigation" width="89%">
                                                                        <a href="TutorialCheatSheet.html">Cheat Sheet</a>
                                                                    </td>
                                                                </tr>
                                                                 
                                                                <tr>
                                                                    <td colspan="3">
                                                                        &nbsp;
                                                                    </td>
                                                                </tr>
                                                            </tbody>
                                                        </table>
														
                                                        <script type="text/javascript">
                                                        var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www.");
                                                        document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));
                                                        </script>
                                                        <script type="text/javascript">
                                                        try {
                                                        var pageTracker = _gat._getTracker("UA-8398936-1");
                                                        pageTracker._trackPageview();
                                                        } catch(err) {}</script>

                                                        <br />
                                                        <div align="center">

                                                            <script src="http://www.gmodules.com/ig/ifr?url=http://www.google.com/ig/modules/translatemypage.xml&up_source_language=en&w=160&h=60&title=&border=&output=js"></script>

                                                        </div>
                                                        <table border="0" cellpadding="0" cellspacing="0" width="96%">
                                                            <tbody>
                                                                <tr>
                                                                    <td colspan="3">
                                                                        &nbsp;
                                                                    </td>
                                                                </tr>
                                                                <tr>
                                                                    <td colspan="3">
                                                                        <div align="center"> 
                                                                        
                                                                        <br />
                                                                        <strong>AnyDbTest awards</strong>
                                                                        
																		
																		<br />
                                                                        <br /> 
																		<a href="http://www.brothersoft.com/anydbtest-download-233099.html" target="_blank">
																			<img src="images/awards/brothersoft_pick_102.gif" alt="BrotherSoft" width="130" height="97" border="0" /></a>	 
																		
                                                                        <br />
                                                                        <br />
                                                                        <!--5 stars-->
                                                                        <a href="http://www.supershareware.com/info/anydbtest.html" target="_blank" >   <img src="images/awards/supershareware_5star.jpg" alt="supershareware"  border="0"  width="130" height="37"/></a>
                                                                        
                                                                        
                                                                        <br />
																		<br />
                                                                        <!--5 stars-->
                                                                        <a href="http://www.finaldownload.com/databases_networks_anydbtest-67017-software.html" target="_blank" >   <img src="images/awards/finaldownload_5stars.gif" alt="finaldownload"  border="0"  width="130" height="80"/></a>

                                                                        <!--5 stars-->
																		<!--
                                                                                                                                                                        <br />
																		<br />
                                                                        
                                                                        <a href="http://www.bestfreewaredownload.com/freeware/t-free-anydbtest-freeware-omfgrphe.html" target="_blank" >   <img src="images/awards/bestfreewaredownload_5star.png.gif" alt="Best Freeware Download"  border="0"  width="130" height="80"/></a>
                                                                                                                                                                         -->

                                                                        
																		
																		<br />
																		<br />
                                                                        <!--5 stars-->
                                                                        <a href="http://www.bestsoftware4download.com/software/t-free-anydbtest-download-csdisjpe.html" target="_blank" >   <img src="images/awards/bestsoftware4download_5star.png" alt="Best Software 4 Download"  border="0"  width="130" height="80"/></a>
                                                                        
																		
																		
                                                                        
                                                                        <br />
																		<br />
                                                                        <!--5 stars-->
                                                                        <a href="http://www.filebuzz.com/fileinfo/55369/AnyDbTest.html" target="_blank" >   <img src="images/awards/filebuzz_5star.jpg" alt="File Buzz"  border="0"  width="130" height="65"/></a>
                                                                        
                                                                                                                                                                                                                        
                                                                        <br />
																		<br />
                                                                        <a href="http://www.bestvistadownloads.com/software/t-free-anydbtest-download-ztxymxxg.html" target="_blank" >   <img src="images/awards/bestvistadownloads_120x60.png" alt="Best Vista Download"  border="0"  width="130" height="65"/></a>
                                                                         
                                                                        
                                                                        </div>
                                                                                
                                                                    </td>
                                                                </tr>
                                                            </tbody>
                                                        </table>
                                                    </div>
                                                </td>
                                            </tr>
                                        </tbody>
                                    </table>
                                </td>
                                <td width="9">
                                    &nbsp;
                                </td>
                            </tr>
                        </tbody>
                    </table>
                </td>
            </tr>
            <tr>
                <td height="46" colspan="3" valign="middle" background="images/layout/site-border-bottom-full.gif" onfocus="MM_preloadImages('images/layout/site-border-bottom-full.gif')">
                    <table width="362" border="0" cellspacing="0" cellpadding="0">
                        <tr>
                            <td width="12" class="menuBottom">
                                &nbsp;
                            </td>
                            <td width="350" class="BottomLinks">
                                &nbsp;&nbsp; <a href="index.html">About AnyDbTest</a>&nbsp;&nbsp;|&nbsp;&nbsp; <a href="license.html">Terms of Usage</a>&nbsp;&nbsp;|&nbsp;&nbsp; <a href="privacy.html">Privacy Policy</a>&nbsp;&nbsp;|&nbsp;&nbsp;
                                <!--
        		<a href="customers.html">Our Clients</a>
                -->
                            </td>
                        </tr>
                    </table>
                </td>
            </tr>
            <tr>
                <td colspan="3" class="copyrightNotice">
                    &nbsp;
                </td>
            </tr>
            <tr>
                <td colspan="3" class="copyrightNotice">
                    <span class="copyrightNotice">Copyright &copy; 2008 - 2010 AnyDbTest Technology. All rights reserved.</span>
                </td>
            </tr>
            <tr>
                <td colspan="3" class="copyrightNoticeProducts">
                    <span class="copyrightNoticeProducts">AnyDbTest are trademarks or registered trademarks of AnyDbTest Technology.</span>
                </td>
            </tr>
        </tbody>
    </table>
    <br />
    <map name="Map" id="Map">
        <area shape="rect" coords="22,19,257,80" href="index.html" alt="AnyDbTest">
    </map>
    <!-- InstanceEnd -->
</body>
</html>
